UCAS Field Mappings
The following tables describe how the UCAS column details are mapped onto ebs Tables/Columns:
Note: Where more than one field is listed, it is the first one in the list that is populated, unless otherwise stated.
UCAS Applicant Details (UCAS_APPLICANT_DETAILS)
Surname
|
People.surname |
|
DateofBirth |
People.date_of_birth |
Set to blank if outside institution defined boundaries |
Firstname |
People.forename and
People.middle_names |
Updated in 4.44 to split into forename and middle names |
Title |
People.title |
Verifier lookup on Title
|
Gender |
People.sex |
Verifier Lookup on Sex
|
NationalInsuranceNumber |
People.ni_number |
|
MobilePhoneNo |
People.mobile_phone_number |
|
NominatedName |
People.fes_next_of_kin |
|
NominatedRelationship |
People.fes_nok_cont_rel |
|
DateEnteredUk |
People.date_uk_entry |
Added in 4.45 |
EmailAddress |
People.personal_email |
|
countryOfBirthCode |
People.place_of_birth |
Verifier code lookup on Nationality
|
preferredFirstname |
People.known_as or People.preferred_first_name |
Added in 4.45 |
uniqueLearnerNumber |
People.unique_learn_no |
|
personalID |
People_ilr.ucasperid |
|
nationalityCode |
People.Nationality |
Verifier code lookup on Nationality (added in 4.44) |
|
Addresses.addess_type |
Institution setting – “UCAS HE ebs Address Type” |
|
Addresses.start_date |
Import Date |
|
Addresses.owner_type |
Hard coded to “P” |
Address1 |
Addresses.address_line_1 |
|
Address2 |
Addresses.address_line_2 |
|
Address3 |
Addresses.address_line_3 |
|
Address4 |
Addresses.address_line_4 |
|
Postcode |
Addresses.uk_post_code_pt1 and a.uk_postcode_pt2 |
|
UCAS Applicant Qualifications (UCAS_APPLICANT_QUALIFICATIONS)
|
Attainments.atype_attainment_type_code |
Institution setting – “UCAS HE Qualification on Entry code” |
subjectOrCourse |
Attainments.description |
Attainment description is “levelcode – subjectOrCourse” |
levelCode |
Attainments.description |
entrydateyear |
Attainments.fes_year_achieved |
If resultorclass is populated. Defaults to current year if not set |
resultOrClass |
Attainments.grade |
|
predictedGrades |
Attainments.fes_predicted_grade |
|
UCAS Applicant Choices (UCAS_APPLICANT_CHOICES)
|
People_units.unit_type |
Hardcoded to “A” |
|
People_units.progress_code |
Institution setting -“Default application progress code” |
|
People_units.progress_date |
Import date |
|
People_units.who_to_pay |
Institution setting, Applications “Who to pay” |
|
People_units.record_date |
Import date |
courseCode |
|
Used to find matching ebs UIO. PointOfEntry Included in matching from 4.46. |
yearOfEntry |
|
pointOfEntry |
|
campus |
|
Optionally used for course matching based on institution setting and reference data |